package com.zhiyou100.mapper;

import com.zhiyou100.entity.Attendance;
import com.zhiyou100.entity.Parent;
import com.zhiyou100.mappers.MyMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;

import java.util.List;

@Mapper
@Component
public interface ParentMapper extends MyMapper<Parent> {
//    private Integer pid;
//
//    private String pname;
//
//    private String pphone;
     @Select("select p.pid pid,p.pname pname,p.pphone pphone from parent p,student_parent sp where p.pid=sp.pid and sp.sid=#{sid}")
     public List<Parent> getAllBySid(Integer sid);
}